Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SYSTEM_CURSOR_CACHE

This view displays similar information to the `V$SESSION_CURSOR_CACHE` view except that this information is system wide.

See Also: "V$SESSION_CURSOR_CACHE"

Column | Datatype | Description
--- | --- | ---
`OPENS` | `NUMBER` | Cumulative total of cursor opens
`HITS` | `NUMBER` | Cumulative total of cursor open hits
`HIT_RATIO` | `NUMBER` | Ratio of the number of times you found an open cursor divided by the number of times you looked for a cursor